Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_OBJECT_SIZE

`DBA_OBJECT_SIZE` lists the sizes, in bytes, of various PL/SQL objects.

Related View

- `USER_OBJECT_SIZE` lists the size of PL/SQL objects owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the object
`NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the object
`TYPE` | `VARCHAR2(12)` |  | Type of the object: `TYPE, TYPE BODY, TABLE, VIEW, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, JAVA SOURCE, JAVA CLASS` or `JAVA RESOURCE`
`SOURCE_SIZE` | `NUMBER` |  | Size of the source in bytes. Must be in memory during compilation, or dynamic recompilation.
`PARSED_SIZE` | `NUMBER` |  | Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object.
`CODE_SIZE` | `NUMBER` |  | Code size, in bytes. Must be in memory when this object is executing.
`ERROR_SIZE` | `NUMBER` |  | Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors.